package com.ship.dispatch.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ship.dispatch.bean.fob.SpFobTemplateFlie;
import com.ship.dispatch.bean.fob.SpFobTemplateFlieVo;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import java.util.List;

public interface SpFobTemplateFlieMapper extends BaseMapper<SpFobTemplateFlie> {
    @Select("select * from sp_fob_template_file where template_id=#{id}")
    List<SpFobTemplateFlieVo> getInfoById(@Param("id") Long id);

    @Delete("DELETE FROM sp_fob_template_file WHERE template_id = #{id}")
    void delByTemplateId(@Param("id") Long id);
}
